Please help

--0__=88BBFBA1DFE205CC8f9e8a93df938690918c88BBFBA1DFE205CC
Content-type: text/plain; charset=US-ASCII





I have reinstalled and uninstalled 4 times now and I keep getting an error
2003 10061 error saying that I can connect to localhost. Please help



Thanks,

Matthew P. Carolan
IBM Certified Professional
Enterprise Systems Management Engineering
Operations Infrastructure Delivery - IBM (OID)
wk 602-537-0510
e-mail: mpcarola@us.ibm.com
--0__=88BBFBA1DFE205CC8f9e8a93df938690918c88BBFBA1DFE205CC--

Re: Please help

Matt Carolan wrote:

> I have reinstalled and uninstalled 4 times now and I keep getting an error
> 2003 10061 error saying that I can connect to localhost. Please help

I assume you're running on Windows.
I'd look at a software firewall blocking the connection attempts (even locally),
or perhaps it's trying to run under an account without local Admin privileges?

--
Peter.


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Please help

On 3/15/06, Peter Monk wrote:
> Matt Carolan wrote:
>
> > I have reinstalled and uninstalled 4 times now and I keep getting an er=
ror
> > 2003 10061 error saying that I can connect to localhost. Please help
>
> I assume you're running on Windows.
> I'd look at a software firewall blocking the connection attempts (even lo=
cally),
> or perhaps it's trying to run under an account without local Admin privil=
eges?

Get the "noinstall" zipped archive and follow instructions at Mysql
Manual for Windows Installing, it seems the installer is getting lost,
so you better use a version that gives you more control over... After
trying it come back to share what happened.

Also take a look at:
http://www.catb.org/~esr/faqs/smart-questions.html

Specially the part about subject lines!

--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Please help

Hi,

Matt Carolan wrote:
>
> I have reinstalled and uninstalled 4 times now and I keep getting an error
> 2003 10061 error saying that I can connect to localhost. Please help
>
did you check if MySQL server is running at all?

Erich

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Please help

--0__=88BBFBA0DFC90FE48f9e8a93df938690918c88BBFBA0DFC90FE4
Content-type: multipart/alternative;
Boundary="1__=88BBFBA0DFC90FE48f9e8a93df938690918c88BBFBA0DF C90FE4"

--1__=88BBFBA0DFC90FE48f9e8a93df938690918c88BBFBA0DFC90FE4
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable






No it's not I can't get it to start. I have it installed on the D Drive=
and
it won't start their. When I reinstall it on the C drive it starts but =
when
I remove it and reinstall it on the D drive it keeps failing. I have
totally cleaned up all directories and the registy before I reinstall b=
ut I
just can't seem to get it to run. I need to get this on my drive becaus=
e
that is where I have the space allocated for the database.

Thanks,

Matthew P. Carolan
IBM Certified Professional
Enterprise Systems Management Engineering
Operations Infrastructure Delivery - IBM (OID)
wk 602-537-0510
e-mail: mpcarola@us.ibm.com



=

Erich Dollansky =


.net.sg> =
To
Matt Carolan/Phoenix/IBM@IBMUS =

03/15/2006 08:29 =
cc
PM win32@lists.mysql.com =

Subj=
ect
Re: Please help =

=

=

=

=

=

=





Hi,

Matt Carolan wrote:
>
> I have reinstalled and uninstalled 4 times now and I keep getting an
error
> 2003 10061 error saying that I can connect to localhost. Please help
>
did you check if MySQL server is running at all?

Erich
=

--1__=88BBFBA0DFC90FE48f9e8a93df938690918c88BBFBA0DFC90FE4
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

No it's not I can't get it to start. I have it installed on the D Dr=
ive and it won't start their. When I reinstall it on the C drive it sta=
rts but when I remove it and reinstall it on the D drive it keeps faili=
ng. I have totally cleaned up all directories and the registy before I =
reinstall but I just can't seem to get it to run. I need to get this on=
my drive because that is where I have the space allocated for the data=
base.



Thanks,



Matthew P. Carolan

IBM Certified Professional

Enterprise Systems Management Engineering

Operations Infrastructure Delivery - IBM (OID)

wk 602-537-0510

e-mail: mpcarola@us.ibm.com



"16" height=3D"16" alt=3D"Inactive hide details for Erich Dollansky <=
;oceanare@pacific.net.sg>">Erich Dollansky <oceanare@pacific.net.=
sg>

0DFC90FE48f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> Erich Dollansky <oceanare@pacific.net.sg>= 03/15/2006 08:29 PM

= 0__=3D88BBFBA0DFC90FE48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> To 100%"> border=3D"0" height=3D"1" width=3D"1" alt=3D""> Matt Carolan/Phoenix/IBM@IBMUS 0__=3D88BBFBA0DFC90FE48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> cc 100%"> border=3D"0" height=3D"1" width=3D"1" alt=3D""> win32@lists.mysql.com 0__=3D88BBFBA0DFC90FE48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""> Subject h=3D"100%"> com" border=3D"0" height=3D"1" width=3D"1" alt=3D""> Re: Please help 0FE48f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""> e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td>

Re: Please help

Hello,

In my.ini have you update in the section :
[mysqld]

the lines :
basedir = D:/The directory of mysql programs
datadir = D:/ The directory of your bases

Bernard

Matt Carolan a écrit :
>
> No it's not I can't get it to start. I have it installed on the D
> Drive and it won't start their. When I reinstall it on the C drive it
> starts but when I remove it and reinstall it on the D drive it keeps
> failing. I have totally cleaned up all directories and the registy
> before I reinstall but I just can't seem to get it to run. I need to
> get this on my drive because that is where I have the space allocated
> for the database.
>
> Thanks,
>
> Matthew P. Carolan
> IBM Certified Professional
> Enterprise Systems Management Engineering
> Operations Infrastructure Delivery - IBM (OID)
> wk 602-537-0510
> e-mail: mpcarola@us.ibm.com
>
> Inactive hide details for Erich Dollansky
> Erich Dollansky
>
>
> *Erich Dollansky *
>
> 03/15/2006 08:29 PM
>
>
>
> To
>
> Matt Carolan/Phoenix/IBM@IBMUS
>
> cc
>
> win32@lists.mysql.com
>
> Subject
>
> Re: Please help
>
>
>
>
> Hi,
>
> Matt Carolan wrote:
> >
> > I have reinstalled and uninstalled 4 times now and I keep getting an
> error
> > 2003 10061 error saying that I can connect to localhost. Please help
> >
> did you check if MySQL server is running at all?
>
> Erich
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Please help

--=_alternative 005FA92185257133_=
Content-Type: text/plain; charset="US-ASCII"

OK, Matt,

Time to step back and understand the nature of what you are trying to set
up. Also time to help you to understand how MySQL allows you to configure
their products.

You are trying to set up a database server. This means there are two
components to make this work. Part one is a program running somewhere that
takes requests and responds with answers. To do this is manages several
files containing data in several places on one or more drives. This part
is the server. Part two is the client. The client makes requests to the
server and handles the responses. There are several types of clients
available to work with MySQL servers. Most of them are designed for human
interaction. I assume you are using one to test your setup (though you
haven't said which one you are using)

=============
PART ONE -- setting up the server. You may or may not have accomplished
any or all of these steps in your previous attempts (we don't know because
you left that information out of your initial posts).

A) FIND THE DOCUMENTATION - How about I just give you this one for free:
http://dev.mysql.com/doc/refman/5.0/en/installing.html
B) READ THE DOCUMENTATION - this is an important step overlooked by many
new administrators. You should try an entire mental "dry run"
installation by reading through the documentation so that you are at least
partially familiar with the process.
C) Locate a copy of the server suitable for your operating system -- there
are pre-compiled binaries (another term for ready-to-use versions) of the
server available for the most popular platforms.
D) Install using a method appropriate for your OS. For windows, you have 3
choices: 1) an unautomated ZIP file (my recommendation), 2) a
self-extracting exe, and 3) an MSI file. Many new users pick the MSI
because they think it will be less hassle. For the over 80% where it works
correctly, this does indeed turn out to be a very hands-off method of
installing the server. I encourage everyone to use the unautomated ZIP.
It's not that hard to follow along and you get a better understanding of
what you are doing and what may be wrong later.
E) configure your installation - edit the config file (on windows it is
called "my.ini") so that when the server is started it knows several very
important bits of information: where you put the data files, what port it
needs to listen to for incoming requests, and anything else about any
option you want to either turn on, turn off, or modify. Details are in the
reading. Most installation packages come with various examples of config
files, each example roughly tuned to different sizes of installations.
Make sure you put this file where the server program can find it (again
details are in the reading and vary by platform)

PART TWO - testing the installation (I think this is where you think you
are)

a) complete part one - this is critical to the success of part two

b) make sure that the server installed in part one is actually running. On
windows systems you can either start the server every time you want to use
it or it can be managed for you as a "service". Services are unautomated
programs that perform a variety of functions. Services are started as the
machine boots and are shutdown as it turns off. Services can also be
manually controlled and configured if the need arises. In a general sense
of the terms a windows service is equivalent to a unix (linux, etc)
daemon. Frequently you will see servers (database servers, web servers,
ftp servers, remote access servers, etc) just called daemons as it applies
to any computing platform.

Refer to the manual for various ways of testing troubleshooting an
installation:
http://dev.mysql.com/doc/refman/5.0/en/post-installation.htm l
http://dev.mysql.com/doc/refman/5.0/en/windows-testing.html
http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooti ng.htm

c) start your client in such a way that it knows where the server is
(which socket or address/port combination) , which mysql you want to use
to make this connection (not which OS user, which database user), and the
password needed to authenticate the account you are using. A typical
command would be (assuming you were already in the folder where mysql.exe
resides) :

mysql -u root

d) send various commands to the server to test that it is responding with
reasonable information - what you can do varies by your level of
experience.

===================


You have left out a LOT of details of what you have and haven't done.
Without more history to your problem, it's very difficult to diagnose its
cause. Should I come to you some day (in your role as systems engineer)
and say "My computer is beeping at me. Help me make it stop" ? You would
need to know what I was doing when the beeping started and what I have
tried to do to make it stop correct? Same with us. The more information
you can give us the easier it will be to get you operational.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


Matt Carolan wrote on 03/16/2006 11:31:04 AM:

> No it's not I can't get it to start. I have it installed on the D
> Drive and it won't start their. When I reinstall it on the C drive
> it starts but when I remove it and reinstall it on the D drive it
> keeps failing. I have totally cleaned up all directories and the
> registy before I reinstall but I just can't seem to get it to run. I
> need to get this on my drive because that is where I have the space
> allocated for the database.
>
> Thanks,
>
> Matthew P. Carolan
> IBM Certified Professional
> Enterprise Systems Management Engineering
> Operations Infrastructure Delivery - IBM (OID)
> wk 602-537-0510
> e-mail: mpcarola@us.ibm.com
>

--=_alternative 005FA92185257133_=--

Re: Please help

On 3/16/06, SGreen@unimin.com wrote:
> OK, Matt,
>
> Time to step back and understand the nature of what you are trying to set
> up. Also time to help you to understand how MySQL allows you to configure
> their products.
>
> You are trying to set up a database server. This means there are two
> components to make this work. Part one is a program running somewhere tha=
t
> takes requests and responds with answers. To do this is manages several
> files containing data in several places on one or more drives. This part
> is the server. Part two is the client. The client makes requests to the
> server and handles the responses. There are several types of clients
> available to work with MySQL servers. Most of them are designed for human
> interaction. I assume you are using one to test your setup (though you
> haven't said which one you are using)
>
> =============3D
> PART ONE -- setting up the server. You may or may not have accomplished
> any or all of these steps in your previous attempts (we don't know becaus=
e
> you left that information out of your initial posts).
>
> A) FIND THE DOCUMENTATION - How about I just give you this one for free:
> http://dev.mysql.com/doc/refman/5.0/en/installing.html
> B) READ THE DOCUMENTATION - this is an important step overlooked by many
> new administrators. You should try an entire mental "dry run"
> installation by reading through the documentation so that you are at leas=
t
> partially familiar with the process.
> C) Locate a copy of the server suitable for your operating system -- ther=
e
> are pre-compiled binaries (another term for ready-to-use versions) of the
> server available for the most popular platforms.
> D) Install using a method appropriate for your OS. For windows, you have =
3
> choices: 1) an unautomated ZIP file (my recommendation), 2) a
> self-extracting exe, and 3) an MSI file. Many new users pick the MSI
> because they think it will be less hassle. For the over 80% where it work=
s
> correctly, this does indeed turn out to be a very hands-off method of
> installing the server. I encourage everyone to use the unautomated ZIP.
> It's not that hard to follow along and you get a better understanding of
> what you are doing and what may be wrong later.
> E) configure your installation - edit the config file (on windows it is
> called "my.ini") so that when the server is started it knows several very
> important bits of information: where you put the data files, what port i=
t
> needs to listen to for incoming requests, and anything else about any
> option you want to either turn on, turn off, or modify. Details are in th=
e
> reading. Most installation packages come with various examples of config
> files, each example roughly tuned to different sizes of installations.
> Make sure you put this file where the server program can find it (again
> details are in the reading and vary by platform)
>
> PART TWO - testing the installation (I think this is where you think you
> are)
>
> a) complete part one - this is critical to the success of part two
>
> b) make sure that the server installed in part one is actually running. O=
n
> windows systems you can either start the server every time you want to us=
e
> it or it can be managed for you as a "service". Services are unautomated
> programs that perform a variety of functions. Services are started as the
> machine boots and are shutdown as it turns off. Services can also be
> manually controlled and configured if the need arises. In a general sens=
e
> of the terms a windows service is equivalent to a unix (linux, etc)
> daemon. Frequently you will see servers (database servers, web servers,
> ftp servers, remote access servers, etc) just called daemons as it applie=
s
> to any computing platform.
>
> Refer to the manual for various ways of testing troubleshooting an
> installation:
> http://dev.mysql.com/doc/refman/5.0/en/post-installation.htm l
> http://dev.mysql.com/doc/refman/5.0/en/windows-testing.html
> http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooti ng.htm
>
> c) start your client in such a way that it knows where the server is
> (which socket or address/port combination) , which mysql you want to use
> to make this connection (not which OS user, which database user), and the
> password needed to authenticate the account you are using. A typical
> command would be (assuming you were already in the folder where mysql.exe
> resides) :
>
> mysql -u root
>
> d) send various commands to the server to test that it is responding with
> reasonable information - what you can do varies by your level of
> experience.
>
> ===================3D
>
>
> You have left out a LOT of details of what you have and haven't done.
> Without more history to your problem, it's very difficult to diagnose its
> cause. Should I come to you some day (in your role as systems engineer)
> and say "My computer is beeping at me. Help me make it stop" ? You would
> need to know what I was doing when the beeping started and what I have
> tried to do to make it stop correct? Same with us. The more information
> you can give us the easier it will be to get you operational.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>

Hey Shawn, can I get permission to use this email as a RTFineM for new
MySQL users? I just couldn't put the right words the way you did... I
guess it is at least 50% of the initial install problems solved...

>
> Matt Carolan wrote on 03/16/2006 11:31:04 AM:
>
> > No it's not I can't get it to start. I have it installed on the D
> > Drive and it won't start their. When I reinstall it on the C drive
> > it starts but when I remove it and reinstall it on the D drive it
> > keeps failing. I have totally cleaned up all directories and the
> > registy before I reinstall but I just can't seem to get it to run. I
> > need to get this on my drive because that is where I have the space
> > allocated for the database.
> >
> > Thanks,
> >

Mathew, as I explained before, the installer is for MOST common
installs, yours is not that common since you'll use a different setup
from the "defaults". Follow Shawn's notes on installing and come back
after you had read, understand and used the docs to do your install.
If the error persists, post back.

> > Matthew P. Carolan
> > IBM Certified Professional
> > Enterprise Systems Management Engineering
> > Operations Infrastructure Delivery - IBM (OID)
> > wk 602-537-0510
> > e-mail: mpcarola@us.ibm.com
> >
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Please help

--=_alternative 006214D485257134_=
Content-Type: text/plain; charset="US-ASCII"

Daniel,

Yes, you have permission to quote this. In fact, I grant everyone
permission to quote this in whole or in part. If you find it useful, good.
If not, please ignore.

Yours,

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"Daniel da Veiga" wrote on 03/16/2006 12:50:15
PM:

> On 3/16/06, SGreen@unimin.com wrote:
> > OK, Matt,
> >
> > Time to step back and understand the nature of what you are trying to
set
> > up. Also time to help you to understand how MySQL allows you to
configure
> > their products.
> >
> > You are trying to set up a database server. This means there are two
> > components to make this work. Part one is a program running somewhere
that
> > takes requests and responds with answers. To do this is manages
several
> > files containing data in several places on one or more drives. This
part
> > is the server. Part two is the client. The client makes requests to
the
> > server and handles the responses. There are several types of clients
> > available to work with MySQL servers. Most of them are designed for
human
> > interaction. I assume you are using one to test your setup (though you
> > haven't said which one you are using)
> >
> > =============
> > PART ONE -- setting up the server. You may or may not have
accomplished
> > any or all of these steps in your previous attempts (we don't know
because
> > you left that information out of your initial posts).
> >
> > A) FIND THE DOCUMENTATION - How about I just give you this one for
free:
> > http://dev.mysql.com/doc/refman/5.0/en/installing.html
> > B) READ THE DOCUMENTATION - this is an important step overlooked by
many
> > new administrators. You should try an entire mental "dry run"
> > installation by reading through the documentation so that you are at
least
> > partially familiar with the process.
> > C) Locate a copy of the server suitable for your operating system --
there
> > are pre-compiled binaries (another term for ready-to-use versions) of
the
> > server available for the most popular platforms.
> > D) Install using a method appropriate for your OS. For windows, you
have 3
> > choices: 1) an unautomated ZIP file (my recommendation), 2) a
> > self-extracting exe, and 3) an MSI file. Many new users pick the MSI
> > because they think it will be less hassle. For the over 80% where it
works
> > correctly, this does indeed turn out to be a very hands-off method of
> > installing the server. I encourage everyone to use the unautomated
ZIP.
> > It's not that hard to follow along and you get a better understanding
of
> > what you are doing and what may be wrong later.
> > E) configure your installation - edit the config file (on windows it
is
> > called "my.ini") so that when the server is started it knows several
very
> > important bits of information: where you put the data files, what
port it
> > needs to listen to for incoming requests, and anything else about any
> > option you want to either turn on, turn off, or modify. Details are in
the
> > reading. Most installation packages come with various examples of
config
> > files, each example roughly tuned to different sizes of installations.
> > Make sure you put this file where the server program can find it
(again
> > details are in the reading and vary by platform)
> >
> > PART TWO - testing the installation (I think this is where you think
you
> > are)
> >
> > a) complete part one - this is critical to the success of part two
> >
> > b) make sure that the server installed in part one is actually
running. On
> > windows systems you can either start the server every time you want to
use
> > it or it can be managed for you as a "service". Services are
unautomated
> > programs that perform a variety of functions. Services are started as
the
> > machine boots and are shutdown as it turns off. Services can also be
> > manually controlled and configured if the need arises. In a general
sense
> > of the terms a windows service is equivalent to a unix (linux, etc)
> > daemon. Frequently you will see servers (database servers, web
servers,
> > ftp servers, remote access servers, etc) just called daemons as it
applies
> > to any computing platform.
> >
> > Refer to the manual for various ways of testing troubleshooting an
> > installation:
> > http://dev.mysql.com/doc/refman/5.0/en/post-installation.htm l
> > http://dev.mysql.com/doc/refman/5.0/en/windows-testing.html
> > http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooti ng.htm
> >
> > c) start your client in such a way that it knows where the server is
> > (which socket or address/port combination) , which mysql you want to
use
> > to make this connection (not which OS user, which database user), and
the
> > password needed to authenticate the account you are using. A typical
> > command would be (assuming you were already in the folder where
mysql.exe
> > resides) :
> >
> > mysql -u root
> >
> > d) send various commands to the server to test that it is responding
with
> > reasonable information - what you can do varies by your level of
> > experience.
> >
> > ===================
> >
> >
> > You have left out a LOT of details of what you have and haven't done.
> > Without more history to your problem, it's very difficult to diagnose
its
> > cause. Should I come to you some day (in your role as systems
engineer)
> > and say "My computer is beeping at me. Help me make it stop" ? You
would
> > need to know what I was doing when the beeping started and what I have
> > tried to do to make it stop correct? Same with us. The more
information
> > you can give us the easier it will be to get you operational.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
>
> Hey Shawn, can I get permission to use this email as a RTFineM for new
> MySQL users? I just couldn't put the right words the way you did... I
> guess it is at least 50% of the initial install problems solved...
>
> >
> > Matt Carolan wrote on 03/16/2006 11:31:04 AM:
> >
> > > No it's not I can't get it to start. I have it installed on the D
> > > Drive and it won't start their. When I reinstall it on the C drive
> > > it starts but when I remove it and reinstall it on the D drive it
> > > keeps failing. I have totally cleaned up all directories and the
> > > registy before I reinstall but I just can't seem to get it to run. I
> > > need to get this on my drive because that is where I have the space
> > > allocated for the database.
> > >
> > > Thanks,
> > >
>
> Mathew, as I explained before, the installer is for MOST common
> installs, yours is not that common since you'll use a different setup
> from the "defaults". Follow Shawn's notes on installing and come back
> after you had read, understand and used the docs to do your install.
> If the error persists, post back.
>
> > > Matthew P. Carolan
> > > IBM Certified Professional
> > > Enterprise Systems Management Engineering
> > > Operations Infrastructure Delivery - IBM (OID)
> > > wk 602-537-0510
> > > e-mail: mpcarola@us.ibm.com
> > >
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>

--=_alternative 006214D485257134_=--

RE: Please help

May I humbly suggest getting managers to read it also? How many of
those folks only want to hear that "Its done" and they don't know or
care what it really takes.

-John C.

-----Original Message-----
From: SGreen@unimin.com [mailto:SGreen@unimin.com]=20
Sent: Friday, March 17, 2006 12:53 PM
To: Daniel da Veiga
Cc: MySQL Win32 List
Subject: Re: Please help


Daniel,

Yes, you have permission to quote this. In fact, I grant everyone=20
permission to quote this in whole or in part. If you find it useful,
good.=20
If not, please ignore.

Yours,

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

"Daniel da Veiga" wrote on 03/16/2006 12:50:15

PM:

> On 3/16/06, SGreen@unimin.com wrote:
> > OK, Matt,
> >
> > Time to step back and understand the nature of what you are trying=20
> > to
set
> > up. Also time to help you to understand how MySQL allows you to
configure
> > their products.
> >
> > You are trying to set up a database server. This means there are two

> > components to make this work. Part one is a program running=20
> > somewhere
that
> > takes requests and responds with answers. To do this is manages
several
> > files containing data in several places on one or more drives. This
part
> > is the server. Part two is the client. The client makes requests=20
> > to
the
> > server and handles the responses. There are several types of=20
> > clients available to work with MySQL servers. Most of them are=20
> > designed for
human
> > interaction. I assume you are using one to test your setup (though=20
> > you haven't said which one you are using)
> >
> > =============3D
> > PART ONE -- setting up the server. You may or may not have
accomplished
> > any or all of these steps in your previous attempts (we don't know
because
> > you left that information out of your initial posts).
> >
> > A) FIND THE DOCUMENTATION - How about I just give you this one for
free:
> > http://dev.mysql.com/doc/refman/5.0/en/installing.html
> > B) READ THE DOCUMENTATION - this is an important step overlooked by
many
> > new administrators. You should try an entire mental "dry run"=20
> > installation by reading through the documentation so that you are at
least
> > partially familiar with the process.
> > C) Locate a copy of the server suitable for your operating system --
there
> > are pre-compiled binaries (another term for ready-to-use versions)=20
> > of
the
> > server available for the most popular platforms.
> > D) Install using a method appropriate for your OS. For windows, you
have 3
> > choices: 1) an unautomated ZIP file (my recommendation), 2) a
> > self-extracting exe, and 3) an MSI file. Many new users pick the
MSI
> > because they think it will be less hassle. For the over 80% where it
works
> > correctly, this does indeed turn out to be a very hands-off method=20
> > of installing the server. I encourage everyone to use the=20
> > unautomated
ZIP.
> > It's not that hard to follow along and you get a better=20
> > understanding
of
> > what you are doing and what may be wrong later.
> > E) configure your installation - edit the config file (on windows it
is
> > called "my.ini") so that when the server is started it knows several
very
> > important bits of information: where you put the data files, what
port it
> > needs to listen to for incoming requests, and anything else about=20
> > any option you want to either turn on, turn off, or modify. Details=20
> > are in
the
> > reading. Most installation packages come with various examples of
config
> > files, each example roughly tuned to different sizes of=20
> > installations. Make sure you put this file where the server program=20
> > can find it
(again
> > details are in the reading and vary by platform)
> >
> > PART TWO - testing the installation (I think this is where you think
you
> > are)
> >
> > a) complete part one - this is critical to the success of part two
> >
> > b) make sure that the server installed in part one is actually
running. On
> > windows systems you can either start the server every time you want=20
> > to
use
> > it or it can be managed for you as a "service". Services are
unautomated
> > programs that perform a variety of functions. Services are started=20
> > as
the
> > machine boots and are shutdown as it turns off. Services can also be

> > manually controlled and configured if the need arises. In a general
sense
> > of the terms a windows service is equivalent to a unix (linux, etc)=20
> > daemon. Frequently you will see servers (database servers, web
servers,
> > ftp servers, remote access servers, etc) just called daemons as it
applies
> > to any computing platform.
> >
> > Refer to the manual for various ways of testing troubleshooting an
> > installation:=20
> > http://dev.mysql.com/doc/refman/5.0/en/post-installation.htm l
> > http://dev.mysql.com/doc/refman/5.0/en/windows-testing.html
> > http://dev.mysql.com/doc/refman/5.0/en/windows-troubleshooti ng.htm
> >
> > c) start your client in such a way that it knows where the server is

> > (which socket or address/port combination) , which mysql you want to
use
> > to make this connection (not which OS user, which database user),=20
> > and
the
> > password needed to authenticate the account you are using. A=20
> > typical command would be (assuming you were already in the folder=20
> > where
mysql.exe
> > resides) :
> >
> > mysql -u root
> >
> > d) send various commands to the server to test that it is responding
with
> > reasonable information - what you can do varies by your level of=20
> > experience.
> >
> > ===================3D
> >
> >
> > You have left out a LOT of details of what you have and haven't=20
> > done. Without more history to your problem, it's very difficult to=20
> > diagnose
its
> > cause. Should I come to you some day (in your role as systems
engineer)
> > and say "My computer is beeping at me. Help me make it stop" ? You
would
> > need to know what I was doing when the beeping started and what I=20
> > have tried to do to make it stop correct? Same with us. The more
information
> > you can give us the easier it will be to get you operational.
> >
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> >
>=20
> Hey Shawn, can I get permission to use this email as a RTFineM for new

> MySQL users? I just couldn't put the right words the way you did... I=20
> guess it is at least 50% of the initial install problems solved...
>=20
> >
> > Matt Carolan wrote on 03/16/2006 11:31:04 AM:
> >
> > > No it's not I can't get it to start. I have it installed on the D=20
> > > Drive and it won't start their. When I reinstall it on the C drive

> > > it starts but when I remove it and reinstall it on the D drive it=20
> > > keeps failing. I have totally cleaned up all directories and the=20
> > > registy before I reinstall but I just can't seem to get it to run.

> > > I need to get this on my drive because that is where I have the=20
> > > space allocated for the database.
> > >
> > > Thanks,
> > >
>=20
> Mathew, as I explained before, the installer is for MOST common=20
> installs, yours is not that common since you'll use a different setup=20
> from the "defaults". Follow Shawn's notes on installing and come back=20
> after you had read, understand and used the docs to do your install.=20
> If the error persists, post back.
>=20
> > > Matthew P. Carolan
> > > IBM Certified Professional
> > > Enterprise Systems Management Engineering
> > > Operations Infrastructure Delivery - IBM (OID)
> > > wk 602-537-0510
> > > e-mail: mpcarola@us.ibm.com
> > >
> >
> >
>=20
>=20
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-=20
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END=20
> GEEK CODE BLOCK------
>=20
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
http://lists.mysql.com/win32?unsub=3Dsgreen@unimin.com
>=20

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Please help

Off topic, but I have to comment because I've seen it far too often. The
answer is, WAY too many. Non-technical managers usually don't know or
care about technical aspects. You're right, they just want to hear that
"it's done", most especially when deployment of a product or solution is
expected to bring an ROI (return on investment) to the organization. Try
explaining to the non-technical manager that a half-million dollars
spent on a solution wouldn't produce an ROI in the current fiscal year
and watch them hit the roof. That's when they turn on the I.T. people
and blame them for it not happening. Sometimes anyways.

From a project perspective, I find the largest problem is that the
"business" managers often go and make product selections too often
without consulting with the I.T. department. They define their product
requirements, send to the providers and when one comes along with the
right price and the claim that they can meet most of if not all the
requirements, they go ahead and sign the deal.

Then it's up to the I.T. folk to reinvent the wheel to make the product
work in their environment. It's a sad story, but I'm sure it happens
very often in the enterprise. Cheers.

Armando

John.Cook@bench.com wrote:
> May I humbly suggest getting managers to read it also? How many of
> those folks only want to hear that "Its done" and they don't know or
> care what it really takes.
>
> -John C.
>
> -----Original Message-----
> From: SGreen@unimin.com [mailto:SGreen@unimin.com]
> Sent: Friday, March 17, 2006 12:53 PM
> To: Daniel da Veiga
> Cc: MySQL Win32 List
> Subject: Re: Please help
>
>
> Daniel,
>
> Yes, you have permission to quote this. In fact, I grant everyone
> permission to quote this in whole or in part. If you find it useful,
> good.
> If not, please ignore.
>
> Yours,
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> "Daniel da Veiga" wrote on 03/16/2006 12:50:15
>
> PM:
>
>
>>On 3/16/06, SGreen@unimin.com wrote:
>>
>>>OK, Matt,
>>>
>>>Time to step back and understand the nature of what you are trying
>>>to
>
> set
>
>>>up. Also time to help you to understand how MySQL allows you to
>
> configure
>
>>>their products.
>>>
>>>You are trying to set up a database server. This means there are two
>
>
>>>components to make this work. Part one is a program running
>>>somewhere
>
> that
>
>>>takes requests and responds with answers. To do this is manages
>
> several
>
>>>files containing data in several places on one or more drives. This
>
> part
>
>>>is the server. Part two is the client. The client makes requests
>>>to
>
> the
>
>>>server and handles the responses. There are several types of
>>>clients available to work with MySQL servers. Most of them are
>>>designed for
>
> human
>
>>>interaction. I assume you are using one to test your setup (though
>>>you haven't said which one you are using)
>>>
>>>=============
>>>PART ONE -- setting up the server. You may or may not have
>
> accomplished
>
>>>any or all of these steps in your previous attempts (we don't know
>
> because
>
>>>you left that information out of your initial posts).
>>>
>>>A) FIND THE DOCUMENTATION - How about I just give you this one for
>
> free:
>
>>>http://dev.mysql.com/doc/refman/5.0/en/installing.html
>>>B) READ THE DOCUMENTATION - this is an important step overlooked by
>
> many
>
>>>new administrators. You should try an entire mental "dry run"
>>>installation by reading through the documentation so that you are at
>
> least
>
>>>partially familiar with the process.
>>>C) Locate a copy of the server suitable for your operating system --
>
> there
>
>>>are pre-compiled binaries (another term for ready-to-use versions)
>>>of
>
> the
>
>>>server available for the most popular platforms.
>>>D) Install using a method appropriate for your OS. For windows, you
>
> have 3
>
>>>choices: 1) an unautomated ZIP file (my recommendation), 2) a
>>>self-extracting exe, and 3) an MSI file. Many new users pick the
>
> MSI
>
>>>because they think it will be less hassle. For the over 80% where it
>
> works
>
>>>correctly, this does indeed turn out to be a very hands-off method
>>>of installing the server. I encourage everyone to use the
>>>unautomated
>
> ZIP.
>
>>>It's not that hard to follow along and you get a better
>>>understanding
>
> of
>
>>>what you are doing and what may be wrong later.
>>>E) configure your installation - edit the config file (on windows it
>
> is
>
>>>called "my.ini") so that when the server is started it knows several
>
> very
>
>>>important bits of information: where you put the data files, what
>
> port it
>
>>>needs to listen to for incoming requests, and anything else about
>>>any option you want to either turn on, turn off, or modify. Details
>>>are in
>
> the
>
>>>reading. Most installation packages come with various examples of
>
> config
>
>>>files, each example roughly tuned to different sizes of
>>>installations. Make sure you put this file where the server program
>>>can find it
>
> (again
>
>>>details are in the reading and vary by platform)
>>>
>>>PART TWO - testing the installation (I think this is where you think
>
> you
>
>>>are)
>>>
>>>a) complete part one - this is critical to the success of part two
>>>
>>>b) make sure that the server installed in part one is actually
>
> running. On
>
>>>windows systems you can either start the server every time you want
>>>to
>
> use
>
>>>it or it can be managed for you as a "service". Services are
>
> unautomated
>
>>>programs that perform a variety of functions. Services are started
>>>as
>
> the
>
>>>machine boots and are shutdown as it turns off. Services can also be
>
>
>>>manually controlled and configured if the need arises. In a general
>
> sense
>
>>>of the terms a windows service is equivalent to a unix (linux, etc)
>>>daemon. Frequently you will see servers (database servers, web
>
> servers,
>
>>>ftp servers, remote access servers, etc) just called daemons as it
>
> applies
>
>>>to any computing platform.
>>>
>>>Refer to the manual for various ways of testing troubleshooting an
>>>installation:
>>>http://dev.mysql.com/doc/refman/5.0/en/post-installation. html
>>>http://dev.mysql.com/doc/refman/5.0/en/windows-testing.ht ml
>>>http://dev.mysql.com/doc/refman/5.0/en/windows-troublesho oting.htm
>>>
>>>c) start your client in such a way that it knows where the server is
>
>
>>>(which socket or address/port combination) , which mysql you want to
>
> use
>
>>>to make this connection (not which OS user, which database user),
>>>and
>
> the
>
>>>password needed to authenticate the account you are using. A
>>>typical command would be (assuming you were already in the folder
>>>where
>
> mysql.exe
>
>>>resides) :
>>>
>>>mysql -u root
>>>
>>>d) send various commands to the server to test that it is responding
>
> with
>
>>>reasonable information - what you can do varies by your level of
>>>experience.
>>>
>>>===================
>>>
>>>
>>>You have left out a LOT of details of what you have and haven't
>>>done. Without more history to your problem, it's very difficult to
>>>diagnose
>
> its
>
>>>cause. Should I come to you some day (in your role as systems
>
> engineer)
>
>>>and say "My computer is beeping at me. Help me make it stop" ? You
>
> would
>
>>>need to know what I was doing when the beeping started and what I
>>>have tried to do to make it stop correct? Same with us. The more
>
> information
>
>>>you can give us the easier it will be to get you operational.
>>>
>>>Shawn Green
>>>Database Administrator
>>>Unimin Corporation - Spruce Pine
>>>
>>
>>Hey Shawn, can I get permission to use this email as a RTFineM for new
>
>
>>MySQL users? I just couldn't put the right words the way you did... I
>>guess it is at least 50% of the initial install problems solved...
>>
>>
>>>Matt Carolan wrote on 03/16/2006 11:31:04 AM:
>>>
>>>
>>>>No it's not I can't get it to start. I have it installed on the D
>>>>Drive and it won't start their. When I reinstall it on the C drive
>
>
>>>>it starts but when I remove it and reinstall it on the D drive it
>>>>keeps failing. I have totally cleaned up all directories and the
>>>>registy before I reinstall but I just can't seem to get it to run.
>
>
>>>>I need to get this on my drive because that is where I have the
>>>>space allocated for the database.
>>>>
>>>>Thanks,
>>>>
>>
>>Mathew, as I explained before, the installer is for MOST common
>>installs, yours is not that common since you'll use a different setup
>>from the "defaults". Follow Shawn's notes on installing and come back
>>after you had read, understand and used the docs to do your install.
>>If the error persists, post back.
>>
>>
>>>>Matthew P. Carolan
>>>>IBM Certified Professional
>>>>Enterprise Systems Management Engineering
>>>>Operations Infrastructure Delivery - IBM (OID)
>>>>wk 602-537-0510
>>>>e-mail: mpcarola@us.ibm.com
>>>>
>>>
>>>
>>>
>>
>>--
>>Daniel da Veiga
>>Computer Operator - RS - Brazil
>>-----BEGIN GEEK CODE BLOCK-----
>>Version: 3.1
>>GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
>>PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END
>>GEEK CODE BLOCK------
>>
>>--
>>MySQL Windows Mailing List
>>For list archives: http://lists.mysql.com/win32
>>To unsubscribe:
>
> http://lists.mysql.com/win32?unsub=sgreen@unimin.com
>
>

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org